Consumer Performance Dashboard

Customer Performance Dashboard – Data Visualization Project

Executive Summary

This Power BI dashboard provides a dynamic and insightful view into customer demographics, purchasing behavior, and revenue distribution. It was designed to help stakeholders make informed decisions by surfacing patterns across customer segments, ultimately optimizing marketing strategies and product offerings.

Project Overview & Problem Statement

The main goal of this project was to gain a clear, data-driven understanding of consumer performance. I aimed to address several key challenges:

• Understanding Revenue Drivers: Identifying which demographics and customer segments contribute most to total revenue.
• Assessing Customer Demographics: Analyzing customer age distribution and the impact of family status (with/without children) on purchasing behavior.
• Geographic Performance: Pinpointing top-performing countries and regions for targeted expansion or marketing efforts.
• Customer Segmentation: Categorizing customers into loyalty tiers (Loyal, VIP, Periodic) to tailor engagement strategies.
• Identifying Top Customers: Recognizing individual high-value customers for personalized outreach.

Data Source

My analysis utilized comprehensive customer transaction data, including details on revenue, demographics (age, gender, family status), and geographic locations. This dataset provided a robust foundation for understanding diverse consumer behaviors.

Methodology

1. Data Acquisition & Understanding: I started by sourcing and thoroughly understanding the various tables within the consumer performance dataset, including customer profiles, transaction records, and demographic information.
2. Data Cleaning & Transformation:
   • I handled missing values and inconsistencies across the tables.
   • Where necessary, I converted data types, especially for numerical and categorical columns.
   • I identified and removed any duplicate entries to ensure the data was accurate and reliable.
3. Data Modeling (Star Schema Design):
   • I created a robust data model in Power BI, establishing clear relationships between all relevant tables (e.g., connecting transactions to customer demographics).
   • I designed a star schema, centralizing core facts like revenue and linking them to dimension tables such as customer profiles and geographic data.
4. DAX Calculations: I developed powerful Data Analysis Expressions (DAX) to create key metrics for my analysis:
   • Calculated Total Revenue, Total Customers, and Average Age.
   • Derived revenue distribution by gender and age group.
   • Segmented customers into loyalty tiers and identified top-performing individuals.
5. Interactive Dashboard Design: I designed an intuitive and visually appealing Power BI dashboard featuring:
   • KPI cards for quick performance monitoring at a glance.
   • Bar charts to compare revenue by age group and customer profiles.
   • Donut charts for clear proportional breakdowns, such as gender revenue distribution and family status.
   • Tables to display top customers and geographic performance.
   • Interactive filters and slicers that allow users to perform dynamic, deep-dive analysis by country, age group, or customer segment.

Key Findings & Insights

Overall Performance & Demographics

• Total Revenue: The dashboard highlights a substantial $307.09 Million in total revenue, indicating a robust market.
• Total Customers: The analysis is based on 18,484 unique customers, providing a solid foundation for understanding consumer behavior.
• Average Age: The average customer age is 45, suggesting a mature customer base.
• Gender Revenue Distribution: Revenue is almost evenly split between genders, with Female customers contributing $154.48 Million (50.30%) and Male customers contributing $152.61 Million (49.70%). This indicates balanced purchasing power across genders.
• Customers with Children: A significant 71% of customers have children, while 29% do not. This demographic split is crucial for targeted marketing and product development.

Geographic Breakdown

• Top Country (Customers with Children): The United States leads with 7,819 customers and $77.42 Million in revenue from customers with children, with an even 50% Male / 50% Female split in this segment.
• Top Country (Customers without Children): Australia is the top country for customers without children, accounting for 3,591 customers and $39.67 Million in revenue, with a slight male majority (51% Male / 49% Female).

Revenue by Age Group

The distribution of revenue across age brackets reveals key purchasing cohorts:

Age Bracket	Revenue (M USD)
21–30	$37.00M
31–40	$79.56M
41–50	$74.55M
51–60	$76.77M
61–70	$39.21M

The 31–60 age range drives over 75% of total revenue, with the 31–40 cohort being the single top-performing segment in terms of revenue generation.

Customer Profiles & Top Performers

• Loyalty Tiers: The dashboard segments customers into distinct profiles based on their spending:
  • Loyal Customers: Account for a substantial $0.27 Billion in revenue.
  • VIP Customers: Contribute $0.10 Billion in revenue.
  • Periodic Customers: Generate $0.02 Billion in revenue.
  This segmentation allows for tailored engagement strategies.
• Top Performing Customers: Individual high-value customers include:
  1. Willie Xu – $0.19 Million
  2. Jordan Turner – $0.19 Million
  3. Margaret He – $0.17 Million
  Recognizing these customers is vital for personalized retention efforts.

Recommendations

• Target Key Age Groups: Focus marketing and product development efforts on the 31-60 age demographic, particularly the 31-40 cohort, as they are the primary revenue drivers.
• Tailor Campaigns by Family Status: Develop distinct marketing campaigns and product recommendations for customers with children versus those without, leveraging the 71%/29% split.
• Geographic Expansion & Localization: Capitalize on strong performance in the United States (for families) and Australia (for customers without children). Explore opportunities for localized strategies in these and other high-potential regions.
• Enhance Loyalty Programs: Develop and refine loyalty programs specifically for "Loyal" and "VIP" customer segments to maximize their lifetime value, given their significant revenue contribution.
• Personalize Outreach to Top Customers: Implement personalized communication and exclusive offers for top-performing customers like Willie Xu, Jordan Turner, and Margaret He to foster continued engagement and loyalty.
• Product Strategy by Gender: Maintain a balanced product offering that appeals to both male and female customers, given their near-equal contribution to overall revenue.

Project Impact & Value Proposition

This project highlights my capability to transform raw data into visually compelling stories and actionable business intelligence. The dashboard enables users to:

• Optimize Marketing Strategies: Spot revenue trends by age, gender, and family status to create more effective and targeted marketing campaigns.
• Enhance Customer Segmentation: Identify and understand key customer segments (e.g., loyalty tiers, geographic groups) for strategic targeting and personalized engagement.
• Inform Product Development: Gain insights into which customer demographics are driving sales, guiding future product offerings and improvements.
• Drive Revenue Growth: Recognize high-value customers and loyalty tiers to focus retention efforts and maximize customer lifetime value.
• Support Data-Driven Decisions: Provide a clear, data-driven foundation for effective business decisions, from marketing and sales to strategic expansion.